package com.ysd.util;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class DBManager {
 private final static String DRIVER = "com.mysql.jdbc.Driver";
 private final static String URL = "jdbc:mysql://localhost:3306/wuyueyuanxian";
 private final static String USER = "root";
 private final static String PWD = "admin";

 public static Connection getConnection() {
  try {// try������ִ��
    // 1.��������
   Class.forName(DRIVER);
   // 2.��������
   Connection conn = DriverManager.getConnection(URL, USER, PWD);
   return conn;// ��������
  } catch (ClassNotFoundException e) {// catch���쳣
   e.printStackTrace();
  } catch (SQLException e) {
   e.printStackTrace();
  }
  return null;
 }

 public static int executeUpdate(String sql) {
  Connection conn = getConnection();
  Statement st = null;
  try {
   st = conn.createStatement();
   int n = st.executeUpdate(sql);
   return n;
  } catch (SQLException e) {
   e.printStackTrace();
   return -1;
  } finally {
   closeAll(conn, st, null);
  }
 }

 // 6.�ر���������
 public static void closeAll(Connection conn, Statement st, ResultSet rs) {
  try {
   if (rs != null) {
    rs.close();
   }
   if (st != null) {
    st.close();
   }
   if (conn != null) {
    conn.close();
   }
  } catch (Exception e) {
   e.printStackTrace();
  }

 }
}